StipendSchedule 
EntityType  Independent 
Logical Entity Name  StipendSchedule 
Default Table Name  SaStipendSched 
Logical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

StipendSchedule Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
StipendScheduleId(PK)    INTEGER  NO 
 
StipendSummaryId(FK)    INTEGER  YES 
 
ScheduledDate    DATETIME  NO 
 
ScheduledAmount    MONEY(19, 4)  NO 
 
Status    CHAR(1)  NO 
 
PreviousStatus    CHAR(1)  YES 
 
CreatedDateTime    DATETIME  NO 
 
LastModifiedDateTime    DATETIME  NO 
 
LastModifiedUserId    INTEGER  NO 
 
RowVersion    TIMESTAMP/DATE  NO 
 
StudentAwardId(FK)    INTEGER  YES 
 
TermId    INTEGER  YES 
 
StipendAddressType    CHAR(1)  YES 
 
StudentRelationshipAddressId(FK)    INTEGER  YES 
 
IsAutomated    BIT  NO 
 
CreditBalanceType    VARCHAR(6)  YES 
 
StudentAccountTransactionId(FK)    INTEGER  YES 
 
ReturnMethod    CHAR(1)  YES 
 
IsAchScheduled    BIT  NO 
 
PayeeName    VARCHAR(55)  YES 
 
CreatedByUserId(FK)    INTEGER  YES 
 
StudentAcademicYearPaymentPeriodId(FK)    INTEGER  YES 
 
DisbursementNumber    SMALLINT  NO 
 
StudentRefundCalculationId(FK)    INTEGER  YES 
 
StudentRelationshipAddressId(FK)    INTEGER  YES 
 

StipendSchedule Keys 
Key Name  Key Type  Keys 
SaStipendSched_StipendAddrID_N_N_IDX  Inversion Entry  StudentRelationshipAddressId 
SaStipendSched_AddUserID_N_N_IDX  Inversion Entry  CreatedByUserId 
SaStipendSched_Status_DateSched_N_N_IDX  Inversion Entry  Status, ScheduledDate 
SaStipendSched_SaStipendSchedID_U_C_IDX  PrimaryKey  StipendScheduleId 
SaStipendSched_FaStudentAyPaymentPeriodId_N_N_IDX  Inversion Entry  StudentAcademicYearPaymentPeriodId 
Nk_SaStipendSchedFaStudentAidID_SaStipendSchedStatus  Inversion Entry  Status 
SaStipendSched_Status_SaStipendID_FaStudentAidID_NetAmount_N_N_IDX  Inversion Entry  Status, ScheduledAmount 

StipendSchedule Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Staff  Non-Identifying  Zero or One to Zero or More        CreatedByUserId  NO 
StudentAcademicYearPaymentPeriod  Non-Identifying  Zero or One to Zero or More        StudentAcademicYearPaymentPeriodId  NO 
StudentRelationshipAddress  Non-Identifying  Zero or One to Zero or More        StudentRelationshipAddressId  NO 
StipendSummary  Non-Identifying  Zero or One to Zero or More        StipendSummaryId  NO 
StudentAccountTransaction  Non-Identifying  Zero or One to Zero or More        StudentAccountTransactionId  NO 
StudentAward  Non-Identifying  Zero or One to Zero or More        StudentAwardId  NO 
StudentRefundCalculation  Non-Identifying  Zero or One to Zero or More        StudentRefundCalculationId  NO 
StudentRelationshipAddress  Non-Identifying  Zero or One to Zero or More        StudentRelationshipAddressId  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
StudentAccountTransactionPendingCheck  Non-Identifying  One To Zero or More          NO 
Refund  Non-Identifying  One To Zero or More          NO 
StipendScheduleDataChange  Non-Identifying  One To Zero or More          NO 
StudentAccountTransactionPendingCheck  Non-Identifying  One To Zero or More          NO 

StipendSchedule Check Constraints 
Check Constraint Name  CheckConstraint 

StipendSchedule Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.StipendSchedule 
NO       
Physical (Microsoft SQL Server)
dbo.SaStipendSched 
NO       

StipendSchedule Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  Refunds_Stipends 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Student Accounts 

StipendSchedule Data Movement Rules 
Name  Type  Rule Text/Value